UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXZkJ+0ekFUnGwIAseEXVoCL4F6e5YWkKm+OBqLl5g0='
WHERE
key_id = 'f458dcd755ac57770fcf567f8720962b504eb2202b78eac7eec5b83b54b8a5ae'
AND (
token = 'pXZkJ+0ekFUnGwIAseEXVoCL4F6e5YWkKm+OBqLl5g0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)