UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't42sgScfWfaDAY5Wj0+tcz8/bok6bS2Lr5vPfHt6/EQ='
WHERE
key_id = '9efd5fbd9ba604b8229482d845ff60702afa4f238a2bcfd116d289de44e95dc4'
AND (
token = 't42sgScfWfaDAY5Wj0+tcz8/bok6bS2Lr5vPfHt6/EQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)