UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a3jJFMl8yXDI86V7sg8elXoAgIT0AJluy6Top3FQlUs='
WHERE
key_id = '4eaa3a5767393c8907d62bd141433e09d5743c1ba43a54f2e5c178ef25eec4df'
AND (
token = 'a3jJFMl8yXDI86V7sg8elXoAgIT0AJluy6Top3FQlUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)