UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pn/psErlX9XFIxjfHFi9bStI0teAeZRb0vEQjFEmXnU='
WHERE
key_id = 'a03fd3c5f34e76ca4d7ff68b0d35df1c1d149e9ad8782fc3825ad214a703fc3f'
AND (
token = 'pn/psErlX9XFIxjfHFi9bStI0teAeZRb0vEQjFEmXnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)