UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mdwFtza4DXoxSebVjl786t6wXtqi4fR5ESjhpTp0tfA='
WHERE
key_id = 'e589a692f84bc135a46c03cda0a384126bc52b176940a9c30e580a2a5ffceabb'
AND (
token = 'mdwFtza4DXoxSebVjl786t6wXtqi4fR5ESjhpTp0tfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)