UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8s6p9tHjsmpUGuEq5/RpbkAghF39lTxMmQN/OnDpLXk='
WHERE
key_id = '3edc6a238c42300bcfdffc29a6955e019868ed3b07ff75b6bc73d0140bc3d3f6'
AND (
token = '8s6p9tHjsmpUGuEq5/RpbkAghF39lTxMmQN/OnDpLXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)