UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oDgIqifzbJ6gKn67YyCtqPMTo1/iG8PvEYp72cwCuTw='
WHERE
key_id = 'df4ef98905cc197f4b2ffd5afe323aa496193a2d828afab1a0042bd7609cbddf'
AND (
token = 'oDgIqifzbJ6gKn67YyCtqPMTo1/iG8PvEYp72cwCuTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)