UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rSwBqjkSGs9YXj6cK6o3lsB0/BpDGy8bukZCyySFO2A='
WHERE
key_id = '6d69fed20100338c4b421cb6b7d74a7a0037d8936b6c6ee2192cf2fef84145ea'
AND (
token = 'rSwBqjkSGs9YXj6cK6o3lsB0/BpDGy8bukZCyySFO2A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)