UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5gC0gFq42+AayF7pjZ+9VVu0M5Cbu15fwicHTadq3pM='
WHERE
key_id = '7b8fb5a97e84dda97bbbf8b83f8d80e70b9659fbc622928ed27435c893562757'
AND (
token = '5gC0gFq42+AayF7pjZ+9VVu0M5Cbu15fwicHTadq3pM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)