UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dVfHoWbxQE5J+T6t4RVqv2EcdfSeLP2tWPZFrrrdug4='
WHERE
key_id = '88505fd719f40551fb16986c6de54842d17890d03bcb6ce4aed892428fe3de12'
AND (
token = 'dVfHoWbxQE5J+T6t4RVqv2EcdfSeLP2tWPZFrrrdug4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)