UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zjX4KDAn3joicKJOEVXxKAucfn75JdfdE5pA8t9qYbs='
WHERE
key_id = '788167364262e7b2b19cc7ac0bf03f31adfd6b914657a7c414bf312830c9e4c7'
AND (
token = 'zjX4KDAn3joicKJOEVXxKAucfn75JdfdE5pA8t9qYbs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)