UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ax7a3BE/nrTsmqdpQ8cWnSR1UsssAEaaQTRjcxNFhpA='
WHERE
key_id = 'a47a7b6bc220a83ee615c78dac619a0ade5f4b9585bc2598a092070c20ee555d'
AND (
token = 'ax7a3BE/nrTsmqdpQ8cWnSR1UsssAEaaQTRjcxNFhpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)