UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CdpKzBzowUI9kqqFidcQiwXKLC7184jvbBcZ8mGOid8='
WHERE
key_id = '815827261a944feb809446924cf8fc23c53a33298bbf60f3f3cc4c472bdf84dc'
AND (
token = 'CdpKzBzowUI9kqqFidcQiwXKLC7184jvbBcZ8mGOid8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)