UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ypB9t9tqpHqaOVzxvSqQrSe6cCixB1k8h2vN1Nhdms8='
WHERE
key_id = '679c918786c670fb3b47aa2d80fbb2acd9bb7d9c7eae9de67803eb89a7fe675f'
AND (
token = 'ypB9t9tqpHqaOVzxvSqQrSe6cCixB1k8h2vN1Nhdms8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)