UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R6b0vwaKdc/w+vsHw27d9AEjNIoSDLwS7kUyWXI/r+s='
WHERE
key_id = '7727cb5a50adb37791e3ff5d92a163461e3c459fce682b1f63aed59f20f1ca60'
AND (
token = 'R6b0vwaKdc/w+vsHw27d9AEjNIoSDLwS7kUyWXI/r+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)