UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nnJjwjNPblo9xImSH17E4Wx2mgGSYn8fwdVVhGhjPQw='
WHERE
key_id = 'cb854c9f8a9d40403e43837bacbf6d9b9ff3221d9e19ff56029c0093a7b5e7e4'
AND (
token = 'nnJjwjNPblo9xImSH17E4Wx2mgGSYn8fwdVVhGhjPQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)