UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PhZrJRTwRKBZ+M4fhD06A/7D5r6Hy2mL0TJiycGiOik='
WHERE
key_id = '8036d27b8450637291b20374425d4e597a1f98df8f8913a5985b52b80d566f9a'
AND (
token = 'PhZrJRTwRKBZ+M4fhD06A/7D5r6Hy2mL0TJiycGiOik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)