UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tmLp7/BJWXno6RUVOqYRK40b8miUzYDq4tuRZVcEAHE='
WHERE
key_id = '37f4e42f7aaefa1909a3a5aa2ab1b45388453e9ff51e99d294cd31c8a9688d7a'
AND (
token = 'tmLp7/BJWXno6RUVOqYRK40b8miUzYDq4tuRZVcEAHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)