UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r5ifM52s4J5Yo82JUsRoDG74M4hbsuZtRBH6Gu+3EyI='
WHERE
key_id = 'bd1d4abdb642d0e2a955eaa2bd0b90f63141ec5c52767eec4d6c39aaf14467ae'
AND (
token = 'r5ifM52s4J5Yo82JUsRoDG74M4hbsuZtRBH6Gu+3EyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)