UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cPX3RzKEbT5N6gXuOZZ2zvTyP4mgUcd/4E80U90PeHU='
WHERE
key_id = '22e0a8e6e32d991be40ff3b8a8b2438dc0d6155e51fe6ab02a792b88360be191'
AND (
token = 'cPX3RzKEbT5N6gXuOZZ2zvTyP4mgUcd/4E80U90PeHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)