UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KNQPJieDPvOBH+H1asMpb6LUkuRR895XK3zo+1njMPc='
WHERE
key_id = 'd38f78dec77f3ca6ae6b0ce53f6594e397614b194009b2372338d90b7a28dfe5'
AND (
token = 'KNQPJieDPvOBH+H1asMpb6LUkuRR895XK3zo+1njMPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)