UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JgNTBeWiEGtEyrboMBmRyQuOqV7HPhaKGeLuo/Z93dY='
WHERE
key_id = '31f58ca6c782bedb06ed33d3e52f0f3b0b3c4e7d8b34819c9b550d4f0fc95c72'
AND (
token = 'JgNTBeWiEGtEyrboMBmRyQuOqV7HPhaKGeLuo/Z93dY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)