UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9qffIAWnwO23SRPH4WE1L0Gks40hzvWk/i7tFkBRj74='
WHERE
key_id = '1f9336f84d4afecfb77f8228974596976a93d8783f342ee9da1a96a2b62bc3fa'
AND (
token = '9qffIAWnwO23SRPH4WE1L0Gks40hzvWk/i7tFkBRj74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)