UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0r/C8nUhyJLBhhOzkxM5hPmPSugXfVEmPeV0Ev6/6ps='
WHERE
key_id = '083d8e66bf8ce800ebb3f6bcf89770b9ea8a52292f2b605152c18e8919285154'
AND (
token = '0r/C8nUhyJLBhhOzkxM5hPmPSugXfVEmPeV0Ev6/6ps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)