UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pLXuiYA2FDQdYDoweO65IRvjesYTyAiQCr/zBt7QsuE='
WHERE
key_id = 'dde486185eaaf272dadcdcc756cdeb0ce20b29123b834dfd32875407191b6200'
AND (
token = 'pLXuiYA2FDQdYDoweO65IRvjesYTyAiQCr/zBt7QsuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)