UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dgyXHMB+5e1kKnq4N2pbHFtk0s9RhtiLYO/bnY0Kdj4='
WHERE
key_id = 'cbb7e66b738ed0571b00ba1e4c83fd46dd7a5b8288965f7b8a5818fa0bdaa500'
AND (
token = 'dgyXHMB+5e1kKnq4N2pbHFtk0s9RhtiLYO/bnY0Kdj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)