UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCIW7hb1MEdYgjR0MQEc/avUk9+o9JRq7JxoO0b6c1k='
WHERE
key_id = 'd38cb286ffbe2fa9d65e4ed3536563dcd1791c6a7ba5641a7261d93352871157'
AND (
token = 'bCIW7hb1MEdYgjR0MQEc/avUk9+o9JRq7JxoO0b6c1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)