UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b+mmaibiqnihYPunM8KXOKyHn9E/9XPscreFgtywFdg='
WHERE
key_id = 'd173b87675b21ff11385ef1851d803c02b92a4fa3da8680f12d31db37d005e36'
AND (
token = 'b+mmaibiqnihYPunM8KXOKyHn9E/9XPscreFgtywFdg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)