UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p2Fw+nGf8RPFsQ/N9r3bGE2SDJCb/pMdLUzUuFHxGN8='
WHERE
key_id = '5c911b293177bc601c8516f4760ac0d4e88de4966d2b8b7492c8c1d13a3a5682'
AND (
token = 'p2Fw+nGf8RPFsQ/N9r3bGE2SDJCb/pMdLUzUuFHxGN8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)