UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mG750ry+sd4Nixdc1ijq+oJnhaeHCFGTQpMBvlZzf+k='
WHERE
key_id = 'c1c6f3508f1d8f4ebf63cf00d19dbf6d93794c46c5674531e58f23647e680f27'
AND (
token = 'mG750ry+sd4Nixdc1ijq+oJnhaeHCFGTQpMBvlZzf+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)