UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Aao4icf3mAOH1Zof2m4gbib/fUf1SV+n+MCYGvJSmA='
WHERE
key_id = '58069c86e2bf178cbabdf3ad8d1b1b465452a459e396dab8b7b6b9c81504b760'
AND (
token = '0Aao4icf3mAOH1Zof2m4gbib/fUf1SV+n+MCYGvJSmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)