UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9LCwGR3P01mwdst4KofJEods4nl81edkLq+QeVhfze4='
WHERE
key_id = '6cf623d782ed6cb86729580bd94d5bfb6cba8ecb20acbe0d1ef7949501f2e0e6'
AND (
token = '9LCwGR3P01mwdst4KofJEods4nl81edkLq+QeVhfze4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)