UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/VPJQeb02+XEEg/s5CaGiL6qDkwMQWQRwuJMwNXMKUc='
WHERE
key_id = 'd6e40a03893aaa9fae9974c33a9687255a9172e31ceaea80861c5380a5200b21'
AND (
token = '/VPJQeb02+XEEg/s5CaGiL6qDkwMQWQRwuJMwNXMKUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)