UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6QKNdB3uST15wxw4LB7SF6/iUCjdD1bu3zAfNqgFa04='
WHERE
key_id = '31d280248e6766379a0f3f632507e1ca75b1024040b2957f161b6041b5b9eebc'
AND (
token = '6QKNdB3uST15wxw4LB7SF6/iUCjdD1bu3zAfNqgFa04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)