UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Cg268R34guWOQ9gcHOVPGS1tUJwL3g9QTe5zcarBBA='
WHERE
key_id = '381b9b9ae31b4fef91e1d82477167493436e00aa75e0c362253c21f61adbd34a'
AND (
token = '2Cg268R34guWOQ9gcHOVPGS1tUJwL3g9QTe5zcarBBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)